To Compact a Database...
- tap on 'Tools' menu
- tap on 'Options' item
- tap on 'Compact Database...' item
Compact Database
Pocket Access databases do not automatically shrink in size
after records are deleted. So, after many inserts/updates/deletes the
database may be bigger in size than it actually needs to be. To force the
Pocket Access database to resize, you can use the 'Compact Database'
feature. Note: you will need approximately 1.5 times the size of the
existing database of available memory and when done the original un-compacted
database will remain as a backup (which you can manually remove, later).